{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Disclaimer","Vertical Curves","Existing Vertical Curves","Symmetrical Vertical Curves","RDM Ex. 2-11"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":54,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Vertical Curves","index":1,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Stopping Sight Distance (SSD) and Passing Sight Distance (PSD)"]
[null,null,null,null,null,null,"Curve VPI Station","Curve Length (ft)","Curve Direction, CREST or SAG","Entrance Grade (%)","Exit Grade (%)","SSDSTEEPER GRADE\n(ft)","KSSD","LMIN, SSD\n(ft)","Meet SSD","KDRIVER COMFORT","LMIN, DRIVER COMFORT\n(ft)","Meet DC","PSD\n(ft)","KPSD","LMIN, PSD\n(ft)","Meet PSD"]
["Design Speed",55,"MPH",null,null,null,null,null,null,null,null,{"$f":"IF(OR($B$3=\"\",H3=\"\",I3=\"\",J3=\"\",K3=\"\"),\"\",ROUNDUP(1.47*$B$3*2.5+$B$3^2/(30*(11.2/32.2-MAX(ABS(J3),ABS(K3))/100)),0))","v":""},{"$f":"IF(L3=\"\",\"\",IF(I3=\"CREST\",ROUNDUP(L3^2/2158,0),IF(I3=\"SAG\",ROUNDUP(L3^2/(400+3.5*L3),0), \" \")))","v":""},{"$f":"IF(M3=\"\",\"\",CEILING(MAX(M3*ABS(J3-K3),3*$B$3),50))","v":""},{"$f":"IF(N3=\"\",\"\",IF(H3>=N3,\"Yes\",\"No\"))","v":""},{"$f":"IF(L3=\"\",\"\",ROUND($B$3^2/46.5,0))","v":""},{"$f":"IF(M3=\"\",\"\",CEILING(MAX(P3*ABS(J3-K3),3*$B$3),50))","v":""},{"$f":"IF(P3=\"\",\"\",IF(H3>=Q3,\"Yes\",\"No\"))","v":""},{"$f":"IF(OR($B$3=\"\",H3=\"\",I3=\"\",J3=\"\",K3=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},{"$f":"IF(S3=\"\",\"\",IF(I3=\"CREST\",ROUND(S3^2/2800,0),\"\"))","v":""},{"$f":"IF(T3=\"\",\"\",CEILING(MAX(T3*ABS(J3-K3),3*$B$3),50))","v":""},{"$f":"IF(U3=\"\",\"\",IF(H3>=U3,\"Yes\",\"No\"))","v":""},null,"Crest Curves",{"$f":"COUNTIF(I3:I48,\"CREST\")","v":0}]
["Maximum Grade",4,"%",null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(L4=\"\",\"\",ROUND($B$3^2/46.5,0))","v":""},{"$f":"IF(M4=\"\",\"\",CEILING(MAX(P4*ABS(J4-K4),3*$B$3),50))","v":""},{"$f":"IF(P4=\"\",\"\",IF(H4>=Q4,\"Yes\",\"No\"))","v":""},{"$f":"IF(OR($B$3=\"\",H4=\"\",I4=\"\",J4=\"\",K4=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","","",null,"Sag Curves",{"$f":"COUNTIF(I3:I48,\"SAG\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H5=\"\",I5=\"\",J5=\"\",K5=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","","",null,"Number of Curves Not Meeting Design Speed SSD",{"$f":"COUNTIF(O3:O48,\"No\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","","",null,"Number of Curves Not Meeting Design Speed PSD",{"$f":"COUNTIF(V3:V48,\"No\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H9=\"\",I9=\"\",J9=\"\",K9=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H10=\"\",I10=\"\",J10=\"\",K10=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H11=\"\",I11=\"\",J11=\"\",K11=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H12=\"\",I12=\"\",J12=\"\",K12=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H13=\"\",I13=\"\",J13=\"\",K13=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H14=\"\",I14=\"\",J14=\"\",K14=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H15=\"\",I15=\"\",J15=\"\",K15=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H16=\"\",I16=\"\",J16=\"\",K16=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H17=\"\",I17=\"\",J17=\"\",K17=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H18=\"\",I18=\"\",J18=\"\",K18=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H19=\"\",I19=\"\",J19=\"\",K19=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H20=\"\",I20=\"\",J20=\"\",K20=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H21=\"\",I21=\"\",J21=\"\",K21=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H22=\"\",I22=\"\",J22=\"\",K22=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H23=\"\",I23=\"\",J23=\"\",K23=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H24=\"\",I24=\"\",J24=\"\",K24=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H25=\"\",I25=\"\",J25=\"\",K25=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H26=\"\",I26=\"\",J26=\"\",K26=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H27=\"\",I27=\"\",J27=\"\",K27=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H28=\"\",I28=\"\",J28=\"\",K28=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H29=\"\",I29=\"\",J29=\"\",K29=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H30=\"\",I30=\"\",J30=\"\",K30=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H31=\"\",I31=\"\",J31=\"\",K31=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H32=\"\",I32=\"\",J32=\"\",K32=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H33=\"\",I33=\"\",J33=\"\",K33=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H34=\"\",I34=\"\",J34=\"\",K34=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H35=\"\",I35=\"\",J35=\"\",K35=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H36=\"\",I36=\"\",J36=\"\",K36=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H37=\"\",I37=\"\",J37=\"\",K37=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H38=\"\",I38=\"\",J38=\"\",K38=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H39=\"\",I39=\"\",J39=\"\",K39=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H40=\"\",I40=\"\",J40=\"\",K40=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H41=\"\",I41=\"\",J41=\"\",K41=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H42=\"\",I42=\"\",J42=\"\",K42=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H43=\"\",I43=\"\",J43=\"\",K43=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H44=\"\",I44=\"\",J44=\"\",K44=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H45=\"\",I45=\"\",J45=\"\",K45=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H46=\"\",I46=\"\",J46=\"\",K46=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H47=\"\",I47=\"\",J47=\"\",K47=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",{"$f":"IF(OR($B$3=\"\",H48=\"\",I48=\"\",J48=\"\",K48=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]

{"sheet":"Existing Vertical Curves","index":2,"n_rows":48,"n_cols":22,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Stopping Sight Distance (SSD) and Passing Sight Distance (PSD)"]
[null,null,null,null,null,null,"Curve VPI Station","Curve Length (ft)","Curve Direction, CREST or SAG","Entrance Grade (%)","Exit Grade (%)","SSDSTEEPER GRADE\n(ft)","KSSD","LMIN, SSD\n(ft)","Meet SSD","PSD\n(ft)","KPSD","LMIN, PSD\n(ft)","Meet PSD"]
["Design Speed",55,"MPH",null,null,null,"HSIP 78-1(10)5",1150,"CREST",-2.8,-6.4,{"$f":"IF(OR($B$3=\"\",H3=\"\",I3=\"\",J3=\"\",K3=\"\"),\"\",ROUNDUP(1.47*$B$3*2.5+$B$3^2/(30*(11.2/32.2-MAX(ABS(J3),ABS(K3))/100)),0))","v":558},{"$f":"IF(L3=\"\",\"\",IF(I3=\"CREST\",ROUNDUP(L3^2/2158,0),IF(I3=\"SAG\",ROUNDUP(L3^2/(400+3.5*L3),0), \" \")))","v":145},{"$f":"IF(M3=\"\",\"\",CEILING(MAX(M3*ABS(J3-K3),3*$B$3),50))","v":550},{"$f":"IF(N3=\"\",\"\",IF(H3>=N3,\"Yes\",\"No\"))","v":"Yes"},{"$f":"IF(OR($B$3=\"\",H3=\"\",I3=\"\",J3=\"\",K3=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},{"$f":"IF(P3=\"\",\"\",IF(I3=\"CREST\",ROUND(P3^2/2800,0),\"\"))","v":289},{"$f":"IF(Q3=\"\",\"\",CEILING(MAX(Q3*ABS(J3-K3),3*$B$3),50))","v":1050},{"$f":"IF(R3=\"\",\"\",IF(H3>=R3,\"Yes\",\"No\"))","v":"Yes"},null,"Crest Curves",{"$f":"COUNTIF(I3:I48,\"CREST\")","v":17}]
["Maximum Grade",4,"%",null,null,null,null,495,"CREST",-6.4,-8.9009999999999998,{"$f":"IF(OR($B$3=\"\",H4=\"\",I4=\"\",J4=\"\",K4=\"\"),\"\",ROUNDUP(1.47*$B$3*2.5+$B$3^2/(30*(11.2/32.2-MAX(ABS(J4),ABS(K4))/100)),0))","v":592},{"$f":"IF(L4=\"\",\"\",IF(I4=\"CREST\",ROUNDUP(L4^2/2158,0),IF(I4=\"SAG\",ROUNDUP(L4^2/(400+3.5*L4),0), \" \")))","v":163},{"$f":"IF(M4=\"\",\"\",CEILING(MAX(M4*ABS(J4-K4),3*$B$3),50))","v":450},{"$f":"IF(N4=\"\",\"\",IF(H4>=N4,\"Yes\",\"No\"))","v":"Yes"},{"$f":"IF(OR($B$3=\"\",H4=\"\",I4=\"\",J4=\"\",K4=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},{"$f":"IF(P4=\"\",\"\",IF(I4=\"CREST\",ROUND(P4^2/2800,0),\"\"))","v":289},{"$f":"IF(Q4=\"\",\"\",CEILING(MAX(Q4*ABS(J4-K4),3*$B$3),50))","v":750},{"$f":"IF(R4=\"\",\"\",IF(H4>=R4,\"Yes\",\"No\"))","v":"No"},null,"Sag Curves",{"$f":"COUNTIF(I3:I48,\"SAG\")","v":15}]
[null,null,null,null,null,null,"Connection on 400' VC",null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H5=\"\",I5=\"\",J5=\"\",K5=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","","",null,"Number of Curves Not Meeting Design Speed SSD",{"$f":"COUNTIF(O3:O48,\"No\")","v":28}]
[null,null,null,null,null,null,"S-289(2)",400,"CREST",-8.3800000000000008,-10.62,620,179,450,"No",{"$f":"IF(OR($B$3=\"\",H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,650,"No",null,"Number of Curves Not Meeting Design Speed PSD",{"$f":"COUNTIF(S3:S48,\"No\")","v":16}]
[null,null,null,null,null,null,null,300,"SAG",-10.62,-3.81,620,150,1050,"No",{"$f":"IF(OR($B$3=\"\",H7=\"\",I7=\"\",J7=\"\",K7=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,520,"SAG",-3.81,1.41,528,125,700,"No",{"$f":"IF(OR($B$3=\"\",H8=\"\",I8=\"\",J8=\"\",K8=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,800,"CREST",1.41,-9.92,608,172,1950,"No",{"$f":"IF(OR($B$3=\"\",H9=\"\",I9=\"\",J9=\"\",K9=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,3300,"No"]
[null,null,null,null,null,null,null,400,"SAG",-9.92,-3,608,147,1050,"No",{"$f":"IF(OR($B$3=\"\",H10=\"\",I10=\"\",J10=\"\",K10=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,600,"SAG",-3,2.2799999999999998,520,122,650,"No",{"$f":"IF(OR($B$3=\"\",H11=\"\",I11=\"\",J11=\"\",K11=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,300,"SAG",2.2799999999999998,4.1120000000000001,531,125,250,"Yes",{"$f":"IF(OR($B$3=\"\",H12=\"\",I12=\"\",J12=\"\",K12=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,600,"CREST",4.1120000000000001,-8.5500000000000007,587,160,2050,"No",{"$f":"IF(OR($B$3=\"\",H13=\"\",I13=\"\",J13=\"\",K13=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,3700,"No"]
[null,null,null,null,null,null,null,800,"SAG",-8.5500000000000007,6.89,587,141,2200,"No",{"$f":"IF(OR($B$3=\"\",H14=\"\",I14=\"\",J14=\"\",K14=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,800,"CREST",6.89,-5.63,564,148,1900,"No",{"$f":"IF(OR($B$3=\"\",H15=\"\",I15=\"\",J15=\"\",K15=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,3650,"No"]
[null,null,null,null,null,null,null,400,"SAG",-5.63,-0.64,549,130,650,"No",{"$f":"IF(OR($B$3=\"\",H16=\"\",I16=\"\",J16=\"\",K16=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,300,"CREST",-0.64,-4.3099999999999996,534,133,500,"No",{"$f":"IF(OR($B$3=\"\",H17=\"\",I17=\"\",J17=\"\",K17=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1100,"No"]
[null,null,null,null,null,null,null,400,"SAG",-4.3099999999999996,5.72,550,131,1350,"No",{"$f":"IF(OR($B$3=\"\",H18=\"\",I18=\"\",J18=\"\",K18=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,400,"CREST",5.72,0,550,141,850,"No",{"$f":"IF(OR($B$3=\"\",H19=\"\",I19=\"\",J19=\"\",K19=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1700,"No"]
[null,null,null,null,null,null,null,400,"CREST",0,-6,553,142,900,"No",{"$f":"IF(OR($B$3=\"\",H20=\"\",I20=\"\",J20=\"\",K20=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1750,"No"]
[null,null,null,null,null,null,null,540,"SAG",-6,7.27,569,136,1850,"No",{"$f":"IF(OR($B$3=\"\",H21=\"\",I21=\"\",J21=\"\",K21=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,600,"CREST",7.27,2.81,569,151,700,"No",{"$f":"IF(OR($B$3=\"\",H22=\"\",I22=\"\",J22=\"\",K22=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1300,"No"]
[null,null,null,null,null,null,null,750,"CREST",2.71,-8.19,582,157,1750,"No",{"$f":"IF(OR($B$3=\"\",H23=\"\",I23=\"\",J23=\"\",K23=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,3200,"No"]
[null,null,null,null,null,null,null,400,"CREST",-8.19,-10.71,621,179,500,"No",{"$f":"IF(OR($B$3=\"\",H24=\"\",I24=\"\",J24=\"\",K24=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,750,"No"]
[null,null,null,null,null,null,null,600,"SAG",-10.71,0,621,150,1650,"No",{"$f":"IF(OR($B$3=\"\",H25=\"\",I25=\"\",J25=\"\",K25=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,800,"CREST",0,-3.73,527,129,500,"Yes",{"$f":"IF(OR($B$3=\"\",H26=\"\",I26=\"\",J26=\"\",K26=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1100,"No"]
[null,null,null,null,null,null,null,400,"SAG",-3.73,1.99,527,124,750,"No",{"$f":"IF(OR($B$3=\"\",H27=\"\",I27=\"\",J27=\"\",K27=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,600,"CREST",1.99,-8.5500000000000007,587,160,1700,"No",{"$f":"IF(OR($B$3=\"\",H28=\"\",I28=\"\",J28=\"\",K28=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,3050,"No"]
[null,null,null,null,null,null,null,400,"SAG",-8.5500000000000007,2.0720000000000001,587,141,1500,"No",{"$f":"IF(OR($B$3=\"\",H29=\"\",I29=\"\",J29=\"\",K29=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,600,"CREST",2.0720000000000001,-3.71,527,129,750,"No",{"$f":"IF(OR($B$3=\"\",H30=\"\",I30=\"\",J30=\"\",K30=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1700,"No"]
[null,null,null,null,null,null,null,600,"CREST",-3.71,-8.33,584,159,750,"No",{"$f":"IF(OR($B$3=\"\",H31=\"\",I31=\"\",J31=\"\",K31=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1350,"No"]
[null,null,null,null,null,null,null,300,"SAG",-8.33,-1.26,584,140,1000,"No",{"$f":"IF(OR($B$3=\"\",H32=\"\",I32=\"\",J32=\"\",K32=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,500,"SAG",-1.26,4.32,534,126,750,"No",{"$f":"IF(OR($B$3=\"\",H33=\"\",I33=\"\",J33=\"\",K33=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,500,"CREST",4.32,-1.41,534,133,800,"No",{"$f":"IF(OR($B$3=\"\",H34=\"\",I34=\"\",J34=\"\",K34=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},289,1700,"No"]
[null,null,null,null,null,null,null,490,"SAG",-1.41,4.9400000000000004,541,128,850,"No",{"$f":"IF(OR($B$3=\"\",H35=\"\",I35=\"\",J35=\"\",K35=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":900},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H36=\"\",I36=\"\",J36=\"\",K36=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H37=\"\",I37=\"\",J37=\"\",K37=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H38=\"\",I38=\"\",J38=\"\",K38=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H39=\"\",I39=\"\",J39=\"\",K39=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H40=\"\",I40=\"\",J40=\"\",K40=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H41=\"\",I41=\"\",J41=\"\",K41=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H42=\"\",I42=\"\",J42=\"\",K42=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H43=\"\",I43=\"\",J43=\"\",K43=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H44=\"\",I44=\"\",J44=\"\",K44=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H45=\"\",I45=\"\",J45=\"\",K45=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H46=\"\",I46=\"\",J46=\"\",K46=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H47=\"\",I47=\"\",J47=\"\",K47=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(OR($B$3=\"\",H48=\"\",I48=\"\",J48=\"\",K48=\"\"),\"\",VLOOKUP($B$3,'RDM Ex. 2-11'!$A$6:$D$18,4,FALSE))","v":""},"","",""]

{"sheet":"Symmetrical Vertical Curves","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["VPI Station","VPI Elevation","Vertical Curve Length (L)","Grade 1, G1 (%)","Grade 2, G2 (%)","Distance X1 (from VPC)","Distance X2 (from VPT)","Grade at X1 (%)","Grade at X2 (%)","X1 Station","X2 Station"]
[null,null,null,null,null,null,null,{"$f":"D2+((E2-D2)/C2)*F2","v":{"$error":"#DIV/0!"}},{"$f":"E2-((E2-D2)/C2)*G2","v":{"$error":"#DIV/0!"}},{"$f":"A2-C2/2+F2","v":0},{"$f":"A2+C2/2-G2","v":0}]
[]
["VPC Station =",{"$f":"A2-C2/2","v":0}]
["VPC Elevation =",{"$f":"B2-D2*(C2/200)","v":0}]
["VPT Station =",{"$f":"B4+C2","v":0}]
["VPT Elevation =",{"$f":"B2+E2*(C2/200)","v":0}]
["Z1 =",{"$f":"(F2^2)*(E2-D2)/(200*C2)","v":{"$error":"#DIV/0!"}}]
["Tangent Elevation1 =",{"$f":"B5+D2*(F2/100)","v":0}]
["Curve Elevation1 = ",{"$f":"B9+B8","v":{"$error":"#DIV/0!"}}]
["Z2 =",{"$f":"(G2^2)*(E2-D2)/(200*C2)","v":{"$error":"#DIV/0!"}}]
["Tangent Elevation2 =",{"$f":"B7-E2*(G2/100)","v":0}]
["Curve Elevation2 = ",{"$f":"B12+B11","v":{"$error":"#DIV/0!"}}]
["XT (from VPC) =",{"$f":"(C2*D2)/(D2-E2)","v":{"$error":"#DIV/0!"}}]
["High or Low Point Station =",{"$f":"B4+B14","v":{"$error":"#DIV/0!"}}]
["High or Low Point Elevation =",{"$f":"B5-(C2*(D2^2))/((E2-D2)*200)","v":{"$error":"#DIV/0!"}}]
["M =",{"$f":"((C2/2)^2)*(E2-D2)/(200*C2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"RDM Ex. 2-11","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,3,4,3],[2,0,4,0],[2,1,2,2],[3,1,4,1],[3,2,4,2]]}
["Exhibit 2-11"]
["Stopping Sight Distances & Minimum K-Values for Crest Vertical Curves"]
["Design Speed (V)\n(mph)","Assumed Speeds",null,"Minimum PSD \nfor Design (ft)"]
[null,"Passed Vehicle (mph)","Passing Vehicle (mph)"]
[]
[20,8,20,400]
[25,13,25,450]
[30,18,30,500]
[35,23,35,550]
[40,28,40,600]
[45,33,45,700]
[50,38,560,800]
[55,43,55,900]
[60,48,60,1000]
[65,53,65,1100]
[70,58,70,1200]
[75,63,75,1300]
[80,68,80,1400]